prepare("select * from stock_prices where sn = $id") ;
$getd->execute() ;
$row = $getd->fetch(pdo::FETCH_ASSOC) ;
$unames = $row['item_name'] ;
//$roomcat = $row['item_category'] ;
$gprice = $row['prices'] ;
if(isset($_POST['submit']))
{
$names = trim($_POST['names']) ;
//$price = trim($_POST['cat']) ;
$price = trim($_POST['price']) ;
$upd = $DBcon->prepare("update stock_prices set prices =:a, date_updated=NOW() where sn = $id") ;
$upd->bindparam(":a",$price) ;
//$upd->bindparam(":b",$price) ;
//$upd->bindparam(":c",$names) ;
if($upd->execute()) header("location: fixprices.php") ;
}
?>
Update Price